Recommended Maintenance

CygNet Software recommends the following periodic database maintenance tasks to keep the datastore in good health.

1. Backups

Perform regular full backups to ensure transaction log cleanup. See Backup and Restore for more information about scheduling backups.

2. Defragmentation

If the database size vastly exceeds the "optimal" size of the database (3000 bytes times the number of database records), perform an offline defragmentation to reclaim disk space. Defragmentation is handled by the ESENTUTL utility. See Database Utilities for more information.

3. Consistency Check

Run the DbsConsistencyCheck utility to check for any logical errors.